package com.huitone.smspfm.dao.oracle;

import java.util.List;
import java.util.Map;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

import com.huitone.smspfm.dao.oracle.entity.SvrNodeCodeRlt;


/**   
* @Title ServiceCodeDef.java
* @Package com.huitone.smspfm.dao.oracle 
* @Description 新加 文件
* @author   wpn
* @date 2
* @version V1.0   
*/
public class ServiceCodeDefDao  extends BaseDao<SvrNodeCodeRlt>{
	@Override
	public List<Map<String,Object>> getAll() {
		String sql ="select  TB_SVR_NODE_CODE_RLT.SVR_NODE,TB_SVR_NODE_CODE_RLT.SERVICE_CODE ,TB_SERVICE_CODE_DEF.SERVICE_NAME,TB_SERVICE_CODE_DEF.ACCEPT_MO  "
				+ "from TB_SVR_NODE_CODE_RLT    "
				+ "JOIN  TB_SERVICE_CODE_DEF  on TB_SVR_NODE_CODE_RLT.SERVICE_CODE = TB_SERVICE_CODE_DEF.SERVICE_CODE  "
				+ "ORDER BY TB_SVR_NODE_CODE_RLT.SVR_NODE   ";
		
		
		List<Map<String,Object>> queryForList = jdbcTemplate.queryForList(sql);
		
		return queryForList;
	}
}
